package com.tma.android.gpm.data.database.util;

public class DatabaseTable {

	public final static String TABLE_SONGS="songs";
	public final static String TABLE_ALBUMS = "albums";
	public final static String TABLE_PLAYLISTS="playlists";
	public final static String TABLE_GENRES ="genres";
	public final static String TABLE_ARTISTS ="artists";
	public final static String TABLE_RECENT ="recent";
	
	
	/**  */
	public final static int DATABASE_VERSION =1;
	public static final String DATABASE_NAME="GMPlayMusic.db";
	
	public static class TableSongs extends DatabaseTable
	{

		public final static String mTotalTracks = "mTotalTracks";
		public final static String mSubjectToCuration= "mSubjectToCuration";
		public final static String mName= "mName";
		public final static String mTotalDiscs= "mTotalDiscs";
		public final static String mTitleNorm= "mTitleNorm";
		public final static String mAlbumNorm= "mAlbumNorm";
		public final static String mTrack= "mTrack";
		public final static String mAlbumArtUrl= "mAlbumArtUrl";
		public final static String mUrl= "mUrl";
		public final static String mCreationDate= "mCreationDate";
		public final static String mAlbumArtistNorm= "mAlbumArtistNorm";
		public final static String mArtistNorm= "mArtistNorm";
		public final static String mLastPlayed= "mLastPlayed";
		public final static String mMatchedId= "mMatchedId";
		public final static String mType= "mType";
		public final static String mDisc= "mDisc";
		public final static String mGenre= "mGenre";
		public final static String mBeatsPerMinute= "mBeatsPerMinute";
		public final static String mAlbum= "mAlbum";
		public final static String mId= "mId";
		public final static String mComposer= "mComposer";
		public final static String mTitle= "mTitle";
		public final static String mAlbumArtist= "mAlbumArtist";
		public final static String mYear= "mYear";
		public final static String mArtist= "mArtist";
		public final static String mDurationMillis= "mDurationMillis";
		public final static String mIsDeleted= "mIsDeleted";
		public final static String mPlayCount= "mPlayCount";
		public final static String mRating= "mRating";
		public final static String mComment= "mComment";
		public final static String mPlaylist_id="mPlaylist_id";
		
		public final static String CREATE_SONGS_TABLE = "CREATE TABLE " +  TABLE_SONGS + "(" + mId + " TEXT PRIMARY KEY,"
															+mTotalTracks +" INTEGER,"
															+ mSubjectToCuration +" BOOLEAN, "
															+ mName + " TEXT, "
															+ mTotalDiscs + " INTEGER, "
															+ mTitleNorm + " TEXT, "
															+ mAlbumNorm + " TEXT, "
															+ mTrack + " INTEGER, "
															+ mAlbumArtUrl + " TEXT, "
															+ mUrl + " TEXT, "
															+ mCreationDate + " LONG, "
															+ mAlbumArtistNorm + " TEXT, "
															+ mArtistNorm +  " TEXT, "
															+ mLastPlayed +  " LONG, "
															+ mMatchedId + " TEXT, "
															+ mType + " INTEGER, "
															+ mDisc + " INTEGER, "
															+ mGenre + " TEXT, "
															+ mBeatsPerMinute + " INTEGER, "
															+ mAlbum + " TEXT, "
															+ mComposer + " TEXT, "
															+ mTitle + " TEXT, "
															+ mAlbumArtist + " TEXT, "
															+ mYear + " INTEGER, "
															+ mArtist + " TEXT, "
															+ mDurationMillis + " INTEGER, "
															+ mIsDeleted + " BOOLEAN, "
															+ mPlayCount + " INTEGER, "
															+ mRating + " TEXT, "
															+ mComment + " TEXT,"
															+  mPlaylist_id + " INTEGER )";

	}
		
	
}
